{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and guidance","Flock input details","Diet input details","Results","References and assumptions log","Calculations - Data tables","Calculations - Dataset"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction and guidance","index":0,"n_rows":79,"n_cols":33,"rows_kept":79,"cut":false,"hidden":false,"merged":[[35,2,35,14],[36,2,37,14],[41,2,42,12],[41,13,42,15],[43,2,63,14],[38,2,38,14],[39,2,39,14],[40,2,40,3],[40,4,40,6],[40,7,40,9],[40,10,40,12],[33,2,33,4],[33,5,33,6],[33,7,33,10],[33,11,33,14],[34,2,34,4],[34,5,34,6],[34,7,34,10],[34,11,34,14],[9,2,12,14],[14,2,15,14],[16,2,17,14],[18,2,31,14],[32,2,32,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Turkey excreta mass balance model"]
[]
[]
[]
[]
[null,null,"Nutritional Management Best Available Techniques for Poultry\n(click here to see regulations)"]
[]
[null,null,"Best Available Techniques (BAT) Reference Document for the Intensive Rearing of Poultry or Pigs \n(click here to see reference document)"]
[]
[null,null,"\nIntroduction:\n\nFarms with more than 40,000 rearing places for poultry fall in scope of regulations requiring the adoption of Best Available Techniques (BAT) to reduce environmental emissions. BAT for pig and poultry farms is outlined in a published BAT Conclusions (BATC) document (see link above). BAT 3 requires farms to reduce total nitrogen excreted whilst BAT 4 requires  the reduction of total phosphorus excreted.  The  BATC include levels for total nitrogen and total phosphorus excreted, measured per animal place. All permitted farms must meet these levels.  \n\nBAT 24 requires the monitoring of total nitrogen and total phosphorus excreted with two recognised methods: Calculation by using a mass balance or estimation using manure analysis results.  Issued permits contain conditions requiring submission of the derived data on an annual basis.  \n\nThis simple spreadsheet tool has been designed to assist farms in assessing compliance with the new BAT for poultry and follows a mass balance calculation approach. The tool is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n\nInstructions:\n\nTo calculate the BAT Emission levels please follow the instructions embedded within each worksheet.  Details of the Flock and Diets need entering in the ‘Flock Input Details’ and ‘Diet Input Details’ worksheets, the emission values and feed intake data will then be calculated in the  ‘Results’ worksheet.  Only when all values are completed within the input forms will the BAT values be calculated. \n\nInputs need to accurately reflect your system usage across the year. You should save a copy of your completed calculator tool in case it is requested as part of future permit compliance checks.\n\nYou will need to read the terms of use below and tick the agree box before you can use the tool.  \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BAT Total Nitrogen and Phosphorus Excreted Levels"]
[null,null,"Parameter",null,null,"Category",null,"BAT-associated total nitrogen excreted ⁽¹⁾⁽²⁾⁽³⁾ \n(kg N excreted/animal place/year)",null,null,null,"BAT-associated total Phosphorus excreted ⁽¹⁾⁽²⁾  \n(kg P₂O₅ excreted/animal place/year)"]
[null,null,"Total nutrient excreted ",null,null,"Turkey",null,"1.0 - 2.3",null,null,null,"0.15 - 1.0"]
[null,null,"(1) The lower end of the range can be achieved by using a combination of techniques. \n(2) The BAT-associated total nitrogen/phosphorus excreted is not applicable to pullets or breeders, for all poultry species. \n(3) The upper end of the range is associated with the rearing of male turkeys.\nThe associated monitoring is in BAT 24. The BAT-associated total phosphorus or nitrogen excreted levels may not be applicable to organic livestock production nor to the rearing of poultry species not indicated above."]
[null,null,"Acknowledgements:\n\nThis simple spreadsheet tool has been designed, based on an update of the previous model (created by AIC), by Ricardo. This work model has been developed on behalf of the Environment Agency alongside a partnership of industry bodies (BPC, BEIC) to assist farms in assessing compliance with the new BAT for poultry. The tool has been reviewed by industry representatives and is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n"]
[]
[null,null,"Terms of use"]
[null,null,"Enter your installation name and permit reference number in the white boxes below:"]
[null,null,"Installation Name:",null,null,null,null,"Permit Number:"]
[null,null,"To use the calculator, first read the terms of use below and tick the box to confirm your acceptance \n(the calculator will not work if this box is not ticked)",null,null,null,null,null,null,null,null,null,null,"Tick to confirm\nacceptance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Terms of use\n\nIn making use of the BAT Emission Calculator (“the Calculator”), I agree to and accept the following:\n1. I understand that the Calculator has been made available to me by the PARTNERS (Environment Agency, BPC, BEIC) (“the Partners”), and that whilst the Partners have used their best endeavours to ensure the accuracy of the Calculator, the Partners accept no liability or responsibility whatsoever for any errors or omissions in the Calculator.\n2. I understand that, so far as is permitted in law, the Partners accept no liability or responsibility whatsoever for any losses, financial penalties or other consequential losses howsoever arising from my use of the Calculator.\n3. It is my responsibility to ensure that the data that I input into the Calculator is accurate and correct.\n4. I accept that the Partners and their employees and agents do not have sufficient knowledge of my individual farm or business to provide advice as to my individual requirements.\n5. I understand that the Calculator is no substitute for professional advice and that I should seek professional advice as to my compliance requirements under any relevant legislation.\n6. I agree that it is my responsibility to ensure that I comply with the relevant compliance requirements under any relevant legislation.\n7. I agree that English law applies to my use of the Calculator, and the Courts of England and Wales have jurisdiction to hear any disputes arising from my use of the Calculator.\n8. I agree that if I am using the Calculator in a professional capacity for the benefit of a client, it is my responsibility as my client’s professional adviser to advise my client on his / her compliance with the relevant requirements under any relevant legislation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please note: If further details on the data inputs and calculations are required, calculation sheets can be unlocked within the model by right clicking the 'Introduction and guidance' tab, clicking 'Unhide...' highlighting each sheet and clicking 'OK'."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Flock input details","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,2],[9,3,9,4],[24,6,26,12],[2,6,22,12]]}
[null,null,null,null,"Input data - flock details"]
[]
[null,"Flock input table 1:",null,null,null,null,"Flock details input instructions\n\nPlease note: One complete workbook needs to be filled out per management system on your farm.  \n\nFlock input table 1:\nEnter number of birds per cycle and number of days between the final clearance and the next cycle in the two white boxes. Note this should reflect the number of birds per cycle not the total annual number of birds. The number of birds per cycle entry cell will go red if the value entered is below 40,000 rearing places, the BAT regulation limit. If you have under 40,000 birds you can still use this tool as normal.\nNote: Number of cycles will not calculate correctly until Flock input table 2 is completed.\n\nFlock input table 2:\nEnter the age of thin(s) to the flock in days and the percentage of birds taken each time in the white boxes. Note, the percentage of thins and clear should total 100%.\n\nFlock input table 3 (optional):\nEnter your value for bodyweight at clear.  The target value is the value from the performance data.  The different in these will be calculated and use to adjust the performance data.\n\nFlock input table 4:\nEnter a percentage value for 7 day mortality in the white box."]
[null,"Per Shed/Farm"]
[null,"Number of birds per cycle"]
[null,"Days empty between cycles"]
[null,"Number of cycles per year",{"$f":"IF(C13=\"\",\"\",IF(C6=\"\",\"\",(365/((C13+(C6/7))*7))))","v":""}]
[]
[null,"Flock input table 2: "]
[null,"Flock Program Summary","Week","Thinning percentage"]
[null,"Age of 1st thin",null,"% 1st thin"]
[null,"Age of 2nd thin",null,"% 2nd thin"]
[null,"Age of clear",null,"% clear"]
[null,null,null,null,{"$f":"SUM(E11:E13)","v":0}]
[]
[null,"Flock input table 3:"]
[null,"Modelling Factors","Your Value","Target Value"]
[null,"Bodyweight (g)",null,{"$f":"(VLOOKUP(C13,Table2[#All],3)*1000)","v":0}]
[]
[null,"Flock input table 4:"]
[null,"Other Factors"]
[null,"7 day mortality (% of flock)"]
[]
[]
[null,null,null,null,null,null,"Performance data available here."]

{"sheet":"Diet input details","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,3,5],[17,1,17,5],[4,1,4,2],[18,1,18,2],[3,7,27,11]]}
[null,null,null,null,"Input data - diet details"]
[]
[null,"Diet input table 1:"]
[null,"Diet Details",null,null,null,null,null,"\nFlock details input instructions\n\nDiet input table 1:\nPlease input protein and phosphorus levels (values can be found on all feed declaration tickets) for the appropriate diets in the white boxes in the \"Diet Details\" table.\nIf the diets are the same (e.g. Grower 1 and 2), then please put the same protein and phosphorus values in both respective sets of boxes\nIf feed diet groups are not used then leave the cells blank and move on to the next used group.\nIf feed is purchased as a blend containing Whole Wheat, and the nutritional information on the packaging includes the whole wheat, the last column of this table can be ignored.\nThere are two additional rows (named 'Editable entry cell') that can be edited to add additional feed diet groups if needed.\n\nDiet input table 2:\nEnter the start and end days within the production cycle for each diet including the proportion (percentage of total ration fed) of the diet that is made up using whole wheat in the final column.  \n\nDiet input table 3:\nState the level of phytase used within the diet. This is a drop down box with predefined additive values, please select the value closest to your phytase addition to feed."]
[null,"Diet",null,"Crude Protein (%)","Total Nitrogen (%)","Total Phosphorus (%)"]
[null,"Ration 1","Editable entry cell",null,{"$f":"D6/6.25","v":0}]
[null,"Ration 2","Editable entry cell",null,{"$f":"D7/6.25","v":0}]
[null,"Ration 3","Editable entry cell",null,0]
[null,"Ration 4","Editable entry cell",null,0]
[null,"Ration 5","Editable entry cell",null,0]
[null,"Ration 6","Editable entry cell",null,0]
[null,"Ration 7","Editable entry cell",null,0]
[null,"Ration 8","Editable entry cell",null,0]
[null,"Ration 9","Editable entry cell",null,{"$f":"D14/6.25","v":0}]
[null,"Whole Wheat","Whole Wheat",null,{"$f":"D15/6.25","v":0}]
[]
[null,"Diet input table 2:"]
[null,"Feed Plan Details"]
[null,"Diet",null,"Feed Start (Week)","Feed End (Week)","Whole Wheat (% of ration)"]
[null,{"$f":"B6","v":"Ration 1"},{"$f":"IF(C6=\"Editable entry cell\",\"\",IF(C6=\"\",\"\",C6))","v":""}]
[null,{"$f":"B7","v":"Ration 2"},{"$f":"IF(C7=\"Editable entry cell\",\"\",IF(C7=\"\",\"\",C7))","v":""}]
[null,"Ration 3",""]
[null,"Ration 4",""]
[null,"Ration 5",""]
[null,"Ration 6",""]
[null,"Ration 7",""]
[null,"Ration 8",""]
[null,"Ration 9",""]

{"sheet":"Results","index":3,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,5,23,7],[24,5,24,7],[25,5,25,7],[11,1,11,3],[10,1,10,7],[11,4,11,7],[23,2,23,3],[24,2,24,3],[25,2,25,3],[22,2,22,7],[14,2,14,4],[14,7,14,8],[3,7,3,8],[3,1,3,2],[6,12,15,17],[3,3,3,4],[7,1,7,3],[8,1,8,3],[6,1,6,7],[7,4,7,7],[8,4,8,7],[3,9,3,10]]}
[null,null,null,null,null,null,"Export data - emission levels"]
[]
[]
[null,"Installation name:",null,{"$f":"'Introduction and guidance'!E41","v":0},null,null,null,"Permit Number:",null,{"$f":"'Introduction and guidance'!K41","v":0}]
[]
[]
[null,"BAT Emission Level",null,null,null,null,null,null,null,null,null,null,"\nResults sheet instructions\n\nUse the data given in this box to demonstrate compliance with the nitrogen and phosphorus excretion levels.\n\nBased on the data entered within the diet and flock details input the emission levels are calculated within the BAT Emission level box, and colour coded green to show compliance with the upper limits of the BAT standards. If the cells turn red then the emission levels are not compliant.\n\n   -  Nitrogen upper limit = 2.3kg N/animal/place/year\n   -  Phosphorus upper limit = 1.0kg P2O5/animal place/year \n"]
[null,"Nitrogen excreted\nPer animal place (kg N/ Year)",null,null,"Phosphorus excreted\nPer animal place (kg P2O5/ Year)"]
[null,{"$f":"H20","v":{"$error":"#VALUE!"}},null,null,{"$f":"I20","v":{"$error":"#VALUE!"}}]
[]
[null,"Percentage of BAT upper Limit"]
[null,{"$f":"B9/2.3","v":{"$error":"#VALUE!"}},null,null,{"$f":"E9/1","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Intake Data",null,null,null,null,"Emission Data"]
[null,null,"Cumulative feed intake (t)","Nitrogen intake (t)","Phosphorus intake (t)",null,null,"Nitrogen excreted (t)","Phosphorus excreted (t)"]
[null,"Per cycle",{"$f":"'Calculations - Dataset'!B124","v":0},{"$f":"'Calculations - Dataset'!C124","v":0},{"$f":"'Calculations - Dataset'!D124","v":0},null,"Per cycle",{"$f":"'Calculations - Dataset'!E124/1000000","v":0},{"$f":"'Calculations - Dataset'!F124/1000000","v":0}]
[null,"Per year",{"$f":"'Calculations - Dataset'!B125","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C125","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!D125","v":{"$error":"#VALUE!"}},null,"Per year",{"$f":"'Calculations - Dataset'!E125/1000000","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!F125/1000000","v":{"$error":"#VALUE!"}}]
[null,null,"Cumulative feed intake (kg)","Nitrogen intake (kg)","Phosphorus intake (kg)",null,null,"Nitrogen excreted (kg)","Phosphorus excreted    (kg)"]
[null,"Per animal place/year",{"$f":"'Calculations - Dataset'!B126/1000","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C126/1000","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!D126/1000","v":{"$error":"#VALUE!"}},null,"Per animal place/year",{"$f":"'Calculations - Dataset'!A116","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!B116","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Emission Levels"]
[null,null,"Per cycle (t)",null,"Per year (t)","kg per Tonne liveweight"]
[null,"Nitrogen",{"$f":"H17","v":0},null,{"$f":"H18","v":{"$error":"#VALUE!"}},{"$f":"((C25*1000)/('Calculations - Dataset'!$B$144/1000))","v":{"$error":"#DIV/0!"}}]
[null,"Phosphorus",{"$f":"I17","v":0},null,{"$f":"I18","v":{"$error":"#VALUE!"}},{"$f":"((C26*1000)/('Calculations - Dataset'!$B$144/1000))","v":{"$error":"#DIV/0!"}}]

{"sheet":"References and assumptions log","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["References and assumptions log"]
[]
["Unique ID","Description with key details ","Location in workbook","Link to evidence","Date of last update","Initials","Methodology behind assumption","Assumptions","Any other comments","Reference or assumption"]
["Poultry 01","This table presents performance data on turkeys from Aviagen",{"$f":"CELL(\"address\",'Calculations - Data tables'!B4)","v":"'[Turkey_Model draft_V6_Password protected.xlsm]Calculations - Data tables'!$B$4"},"POBRB6_V6_BUT 6_Breeder Goals_UK_2023 - Turkey Performance Obs.pdf",44977,"LR","This data has been used to pull out body weight and cumulative intake values for Turkey","The data is presented in grams per day.","None.  ","Reference"]
["Poultry 02","Nitrogen Conversion Factor",{"$f":"CELL(\"address\",'Calculations - Data tables'!B41)","v":"'[Turkey_Model draft_V6_Password protected.xlsm]Calculations - Data tables'!$B$41"},"FAO (N.D>) https://www.fao.org/3/y5022e/y5022e03.htm#:~:text=On%20the%20basis%20of%20early,nitrogen%20content%20into%20protein%20content.",44977,"LR","This factor is used to convert crude protein content of feed to nitrogen.","Does not consider specifics of individual feeds but is a standardised factor used within the industry.","None.","Reference"]
["Poultry 03","Retention factors of nitrogen and phosphorus in turkeys",{"$f":"CELL(\"address\",'Calculations - Data tables'!B49)","v":"'[Turkey_Model draft_V6_Password protected.xlsm]Calculations - Data tables'!$B$49"},"Determination of Nutrient Mass Balance in Turkeys | Elsevier Enhanced Reader",44959,"LR","This data has been used to calculate the rate of retention of nitrogen and phosphorus in turkeys","This data is based on an American production system.","None.","Reference"]
["Poultry 04","Effect of Phytase on intake and excretion of phosphorus","None","None",44988,"LR","None","High quality data to that presents the impact of phytase inclusion on excretion of nitrogen or phosphorus could not be found at this stage.","This can be updated in the model if relevant data is found ","Assumption"]
["Poultry 05","Phytase feed additives effect on nitrogen","None","None",44988,"LR","None","Within the model calculations nitrogen is not impacted by phytase, this is an assumption based on current literature. ","This can be updated in the model a link is found.","Assumption"]
["Poultry 06","N and P retention factors","None","None",44988,"LR","None","The N and P retention factors do not require editing by user - the factors used in this model are from Assuena et al. (2009) ","This can be updated in the model a link is found.","Assumption"]
["Poultry 07","Liveweight data","None","None",44988,"LR","None","We have included weighted average and liveweight to the dataset page as these are not required to be updated by the input user.","None","Assumption"]
["Poultry 08","Broiler performance data","None","None",44988,"LR","None","Currently the broiler performance data is based on \"As Hatched\" data which means it is a combination of both sexes.","None","Assumption"]
["Poultry 09","Upper BAT limit for excretion values are based on male turkeys","None","None",44988,"LR","None","These values are taken from the JRC BREF document ","None ","Assumption"]

{"sheet":"Calculations - Data tables","index":5,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":true,"merged":[[53,3,53,4]]}
["Data tables holding background data"]
[]
["Table 1. Poultry cumulative feed intake"]
["Source: ","Poultry 01"]
["This table presents performance data on turkeys produced by Aviagen"]
[]
["Week","Day","Weight (kg)","Feed (g/b/d)","Cumulative feed (kg)"]
[{"$f":"Table2[[#This Row],[Day]]/7","v":0},0,0,0,0]
[{"$f":"Table2[[#This Row],[Day]]/7","v":1},7,0.15,37,0.26]
[{"$f":"Table2[[#This Row],[Day]]/7","v":2},14,0.27,43,0.56000000000000005]
[{"$f":"Table2[[#This Row],[Day]]/7","v":3},21,0.5,55,0.95]
[{"$f":"Table2[[#This Row],[Day]]/7","v":4},28,0.82,71,1.44]
[{"$f":"Table2[[#This Row],[Day]]/7","v":5},35,1.22,91,2.08]
[{"$f":"Table2[[#This Row],[Day]]/7","v":6},42,1.68,115,2.88]
[{"$f":"Table2[[#This Row],[Day]]/7","v":7},49,2.2000000000000002,140,3.86]
[{"$f":"Table2[[#This Row],[Day]]/7","v":8},{"$f":"B15+7","v":56},2.76,168,5.04]
[{"$f":"Table2[[#This Row],[Day]]/7","v":9},{"$f":"B16+7","v":63},3.36,196,6.41]
[{"$f":"Table2[[#This Row],[Day]]/7","v":10},{"$f":"B17+7","v":70},3.98,225,7.99]
[{"$f":"Table2[[#This Row],[Day]]/7","v":11},77,4.62,253,9.76]
[{"$f":"Table2[[#This Row],[Day]]/7","v":12},84,5.27,280,11.72]
[{"$f":"Table2[[#This Row],[Day]]/7","v":13},91,5.92,305,13.85]
[{"$f":"Table2[[#This Row],[Day]]/7","v":14},98,6.56,327,16.14]
[{"$f":"Table2[[#This Row],[Day]]/7","v":15},105,7.19,348,18.579999999999998]
[{"$f":"Table2[[#This Row],[Day]]/7","v":16},112,7.81,365,21.13]
[{"$f":"Table2[[#This Row],[Day]]/7","v":17},119,8.41,379,23.79]
[{"$f":"Table2[[#This Row],[Day]]/7","v":18},126,8.98,390,26.52]
[{"$f":"Table2[[#This Row],[Day]]/7","v":19},133,9.5299999999999994,399,29.31]
[{"$f":"Table2[[#This Row],[Day]]/7","v":20},140,10.050000000000001,405,32.14]
[{"$f":"Table2[[#This Row],[Day]]/7","v":21},147,10.55,408,35]
[{"$f":"Table2[[#This Row],[Day]]/7","v":22},154,11.01,409,37.86]
[{"$f":"Table2[[#This Row],[Day]]/7","v":23},161,11.45,409,40.729999999999997]
[{"$f":"Table2[[#This Row],[Day]]/7","v":24},168,11.86,405,43.56]
[{"$f":"Table2[[#This Row],[Day]]/7","v":25},175,12.24,401,46.37]
[{"$f":"Table2[[#This Row],[Day]]/7","v":26},182,12.61,396,49.14]
[{"$f":"Table2[[#This Row],[Day]]/7","v":27},189,12.95,390,51.87]
[{"$f":"Table2[[#This Row],[Day]]/7","v":28},196,13.28,382,54.54]
[{"$f":"Table2[[#This Row],[Day]]/7","v":29},203,13.6,374,57.16]
[]
[]
["Table 2. Protein/Nitrogen Conversion Factor"]
["Source: ","Poultry 02"]
["Factor to convert crude protein content to nitrogen content. E.g. g protein in the feed per g N in the feed."]
[]
["Protein to nitrogen conversion factor:"]
[6.25]
[]
[]
["Table 3. N and P Retention in Turkeys"]
["Source: ","Poultry 03","Applegate et al. 2008"]
["Phytase feed additive intake impacts"]
[]
[null,"Determination of Nutrient Mass Balance in Turkeys | Elsevier Enhanced Reader"]
[]
[]
[null,"Item","Age (wk)","Industry"]
[null,"Nitrogen"]
[null,"g/bird","0 to 12",388]
[null,null,"0 to 15","641.4a"]
[null,null,"0 to 18",938.5]
[null,"%","0 to 12",81.400000000000006]
[null,null,"0 to 15",82.1]
[null,null,"0 to 18",86.7]
[null,"Phosphorus"]
[null,"g/bird","0 to 12","65.3a"]
[null,null,"0 to 15","116.0a"]
[null,null,"0 to 18","201.3a"]
[null,"%","0 to 12","52.8a"]
[null,null,"0 to 15","56.1a"]
[null,null,"0 to 18","67.2a"]

{"sheet":"Calculations - Dataset","index":6,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
["Calculations"]
[]
["Table 1. Bodyweight and Cumulative feed intake"]
["Source: ","Poultry 01"]
["This table contains the assumed bodyweights and cumulative feed intake for the animals based on the Aviagen performance objectives and the end day of each phase"]
[]
["Diet type","Bodyweight (g)","Cumulative feed intake (g) ","Wholewheat intake (%)","Compound feed intake (%)","Wholewheat intake (g)","Compound feed intake (g)"]
["Starter crumb",{"$f":"(VLOOKUP('Diet input details'!E20,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F20","v":0},{"$f":"1-D8","v":1},{"$f":"D8*C8","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E8*C8,0)","v":0}]
["Starter pellet",{"$f":"(VLOOKUP('Diet input details'!E21,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F21","v":0},{"$f":"1-D9","v":1},{"$f":"D9*(C9-C8)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E9*(C9-C8),0)","v":0}]
["Rearer pellet",{"$f":"(VLOOKUP('Diet input details'!E22,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F22","v":0},1,{"$f":"D10*(C10-C9)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E10*(C10-C9),0)","v":0}]
["Grower pellet 1",{"$f":"(VLOOKUP('Diet input details'!E23,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F23","v":0},1,{"$f":"D11*(C11-C10)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E11*(C11-C10),0)","v":0}]
["Grower pellet 2",{"$f":"(VLOOKUP('Diet input details'!E24,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F24","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E12*(C12-C11),0)","v":0}]
["Finisher pellet",{"$f":"(VLOOKUP('Diet input details'!E25,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F25","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E13*(C13-C12),0)","v":0}]
["Withdrawal pellet",{"$f":"(VLOOKUP('Diet input details'!E26,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F26","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E14*(C14-C13),0)","v":0}]
["Not used",{"$f":"(VLOOKUP('Diet input details'!E27,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F27","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E15*(C15-C14),0)","v":0}]
["Not used",{"$f":"(VLOOKUP('Diet input details'!E28,Perf_Data,3)*1000)*($A$152)","v":0},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,5)*1000","v":0},{"$f":"'Diet input details'!F28","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cumulative feed intake (g) ]]>0,E16*(C16-C15),0)","v":0}]
["Total",{"$f":"SUMIF(B8:B16,\"<>#N/A\")","v":0},{"$f":"SUMIF(C8:C16,\"<>#N/A\")","v":0},null,null,{"$f":"SUMIF(F8:F16,\"<>#N/A\")","v":0},{"$f":"SUMIF(G8:G16,\"<>#N/A\")","v":0}]
[]
[]
["Table 2. N and P Intake"]
["Source: ","N/A"]
["This table contains the N and P intake at each phase based on the cumulative feed intake (Table 1 from 'Data tables'), and the nutrient status of the feed (from 'Diet input details')"]
[]
["Diet type","Feed Nitrogen conc. (%)","Feed Phosphorus conc. (%)","Wholewheat Nitrogen conc. (%) ","Wholewheat Phosphorus conc. (%)","Compound feed Nitrogen consumed (g)","Compound feed Phosphorus consumed (g)","Wholewheat Nitrogen consumed (g)","Wholewheat Phosphorus consumed (g)","Total Nitrogen consumed (g)","Total Phosphorus consumed (g)"]
["Starter crumb",{"$f":"'Diet input details'!D6/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F6","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},{"$f":"B25%*G8","v":0},{"$f":"C25%*G8","v":0},{"$f":"D25%*F8","v":0},{"$f":"E25%*F8","v":0},{"$f":"F25+H25","v":0},{"$f":"G25+I25","v":0}]
["Starter pellet",{"$f":"'Diet input details'!D7/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F7","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,{"$f":"F26+H26","v":0},{"$f":"G26+I26","v":0}]
["Rearer pellet",{"$f":"'Diet input details'!D8/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F8","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,{"$f":"G27+I27","v":0}]
["Grower pellet 1",{"$f":"'Diet input details'!D9/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F9","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Grower pellet 2",{"$f":"'Diet input details'!D10/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F10","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Finisher pellet",{"$f":"'Diet input details'!D11/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F11","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Withdrawal pellet",{"$f":"'Diet input details'!D12/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F12","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Not used",{"$f":"'Diet input details'!D13/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F13","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Not used",{"$f":"'Diet input details'!D14/'Calculations - Data tables'!$A$45","v":0},{"$f":"'Diet input details'!F14","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"'Diet input details'!$F$15","v":0},0,0,0,0,0,0]
["Total ",null,null,null,null,{"$f":"SUMIF(F25:F33,\"<>#N/A\")","v":0},{"$f":"SUMIF(G25:G33,\"<>#N/A\")","v":0},0,0,0,0]
[]
[]
["Table 3. Effect of Phytase/Feed Additive"]
["Source: "]
["Not applicable at this time. A gap has been left for Phytase calculations, but currently phytase additive factor values have not been found within the evidence review for Turkeys."]
[]
[]
[]
[]
["Table 4. Retention Factor"]
["Source: ","Poultry 03","Applegate et al. 2008"]
["Presents the N and P retention factor that will be used based on the level of phytase inclusion in diet from the 'Flock input'"]
[]
["Retention factor","Value","Factor"]
["Nitrogen ",86.7,{"$f":"(100-Table4_phyt_factors[[#This Row],[Value]])/100","v":0.13299999999999998}]
["Phosphorus",67.2,{"$f":"(100-Table4_phyt_factors[[#This Row],[Value]])/100","v":0.32799999999999996}]
[]
[]
["Table 5. N and P Retained "]
["Source: ","Table 2/Table 4 from 'Dataset'"]
["This table shows the amount of N and P that is retained in the body weight of the animal "]
[]
["Diet type","Nitrogen retained (g)","Phosphorus retained (g)"]
["Starter crumb",{"$f":"J25*$C$49","v":0},{"$f":"K25*$C$50","v":0}]
["Starter pellet",0,0]
["Rearer pellet",0,0]
["Grower pellet 1",0,0]
["Grower pellet 2",0,0]
["Finisher pellet",0,0]
["Withdrawal pellet",0,0]
["Not used",0,0]
["Not used",0,0]
[]
["Table 6. N and P excreted"]
["Source: ","Table 5 from 'Dataset'"]
["N and P ingested (Table 2) take away N and P retained (Table 4)"]
[]
["Diet type","Nitrogen excreted (g)","Phosphorus excreted (g)"]
["Starter crumb",{"$f":"J25-B58","v":0},{"$f":"K25-C58","v":0}]
["Starter pellet",0,0]
["Rearer pellet",0,0]
["Grower pellet 1",0,0]
["Grower pellet 2",0,0]
["Finisher pellet",0,0]
["Withdrawal pellet",0,0]
["Not used",0,0]
["Not used",0,0]
[]
["Table 7. Thinning Values"]
["Source: ","Flock input details' "]
["This table presents the thinning factors that can be used to adjust the excretion values from Table 5"]
[]
[null,"Thinning %","Thinning value"]
[null,{"$f":"'Flock input details'!E11","v":0},{"$f":"B88","v":0}]
[null,{"$f":"'Flock input details'!E12","v":0},{"$f":"IF(B89>0,B89,B90)","v":0}]
[null,{"$f":"'Flock input details'!E13","v":0},{"$f":"IF(B89>0,B90,0)","v":0}]
["100% check ",{"$f":"SUM(B88:B90)=100%","v":false},{"$f":"SUM(C88:C90)=100%","v":false}]
[]
[]
["Table 8. Thinned Excretion Values"]
["Source: ","Table 6/Table 7 from 'Dataset'"]
["This table presents the N and P excretion from Table 5, adjusted to reflect the amount of birds thinned using the thinning value in Table 6"]
[]
["Diet type","Nitrogen Excreted (g)","Phosphorus Excreted (g)"]
["Starter crumb",{"$f":"B73","v":0},0]
["Starter pellet",0,0]
["Rearer pellet",0,0]
["Grower pellet 1",0,0]
["Grower pellet 2",0,0]
["Finisher pellet",{"$f":"B78*$C$89","v":0},{"$f":"C78*$C$89","v":0}]
["Withdrawal pellet",{"$f":"B79*$C$89","v":0},{"$f":"C79*$C$89","v":0}]
["Not Used ",{"$f":"B80*$C$89","v":0},0]
["Not Used ",0,0]
["TOTAL",{"$f":"SUMIF(B99:B107,\"<>#N/A\")","v":0},{"$f":"SUMIF(C99:C107,\"<>#N/A\")","v":0}]
[]
[]
["Table 9. Nutrient excretion (kg/animal place/year)"]
["Source: "]
["This table converts the excretion values presented in Table 8 from grams per bird to kg/animal place/year.  The total nutrient excreted (from Table 8) is multiplied by cycles per year (from 'Flock input details'), and then divided by 1000 to convert from g to kg"]
["This table also converts P to P2O5 by dividing by 0.437"]
["Nitrogen excretion (kg/animal place/year)","Phosphorus excretion (kg/animal place/year)"]
[{"$f":"(B108*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"((C108*'Flock input details'!C7)/1000)/0/437","v":{"$error":"#VALUE!"}}]
[]
[]
["Table 10. Per cycle/Per year values "]
["Source: ","N/A"]
["This table presents the intake and excreted values on a per cycle and per basis .  These values are based off what has been calculated in the tables above and the days input to 'Model 1 - flock or herd details'"]
[]
["Per cycle/year","Feed Intake (g)","Nitrogen Intake (g)","Phosphorus Intake (g)","Nitrogen Excretion (g)","Phosphorus Excretion (g)"]
["Per cycle",{"$f":"(G17*'Flock input details'!C5)/1000000","v":0},{"$f":"(J34*'Flock input details'!C5)/1000000","v":0},{"$f":"(K34*'Flock input details'!C5)/1000000","v":0},{"$f":"(B108*'Flock input details'!C5)","v":0},{"$f":"(C108*'Flock input details'!C5)","v":0}]
["Per year",{"$f":"B124*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"C124*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"D124*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"E124*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"F124*'Flock input details'!C7","v":{"$error":"#VALUE!"}}]
["Per animal place/per year",{"$f":"(G17*'Flock input details'!C7)","v":{"$error":"#VALUE!"}},{"$f":"(J34*'Flock input details'!C7)","v":{"$error":"#VALUE!"}},{"$f":"(K34*'Flock input details'!C7)","v":{"$error":"#VALUE!"}},{"$f":"E125*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"F125*'Flock input details'!C7","v":{"$error":"#VALUE!"}}]
[]
["Table 11. Weighted Avg. Bird Weight"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
["Thinning","Bodyweight after thins (g)","Bodyweight after mortality (g)","Bodyweight after chick mortality (g)"]
["1 thin",{"$f":"((VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE)*'Flock input details'!E11)+(VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE)*'Flock input details'!E13))*1000","v":0},{"$f":"B133*(1-'Flock input details'!$C$22)","v":0},{"$f":"C133-($B$8*'Flock input details'!$C$22)","v":0}]
["2 thins",{"$f":"((VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE)*'Flock input details'!E11)+(VLOOKUP('Flock input details'!C12,Perf_Data,3,FALSE)*'Flock input details'!E12)+(VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE)*'Flock input details'!E13))*1000","v":0},{"$f":"B134*(1-'Flock input details'!$C$22)","v":0},{"$f":"C134-($B$8*'Flock input details'!$C$22)","v":0}]
[]
[]
["Table 12. Liveweight Calcs"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
[]
["Weight group","kg"]
["Weighted Ave. Bird weight (kg)",{"$f":"(IF('Flock input details'!C12>0,'Calculations - Dataset'!D134,'Calculations - Dataset'!D133))/1000*Table5[% of Target bodyweight]","v":0}]
["Liveweight/Crop (kg)",{"$f":"B143*('Flock input details'!C5*(1-'Flock input details'!C22))","v":0}]
[]
[]
["Table 13. Bodyweight Adjustment"]
["Source: ","N/A"]
["This calculates the % of the target bodyweight that the average bird in the system is reaching at clear"]
[]
["% of Target bodyweight"]
[{"$f":"IF('Flock input details'!C18=0,1,('Flock input details'!C18/'Flock input details'!D18))","v":1}]